﻿CREATE TABLE [dbo].[JF_T_User]
(
	[Id] INT NOT NULL PRIMARY KEY,
	[Account] NVARCHAR(32) NOT NULL,
	[Name] NVARCHAR(32) NOT NULL,
	[Password] NVARCHAR(64) NOT NULL,
	[CreatedTime] DATETIME NOT NULL,
	[EMail] NVARCHAR(128) NOT NULL,
	[Mobile] NVARCHAR(16) NOT NULL,
	[NickName] NVARCHAR(32) NULL,
	[AvatarUrl] NVARCHAR(32) NULL,
	[Address] NVARCHAR(256) NULL,
	[PostalCode] NVARCHAR(16) NULL,
	[Country] NVARCHAR(32) NULL,
	[City] NVARCHAR(16) NULL,
	[BirthDate] DATETIME NULL,
    [Gender] SMALLINT NULL,
	[LatestLogOnTime] datetime NULL,
	[LatestLogOnIP] nvarchar(32) NULL,
	[UnlockTime] datetime NULL,
	[Status] int NOT NULL,
	[IsPrivate] bit NOT NULL
)
